package com.yuda.tools.detection.tool;

import org.springframework.jdbc.core.JdbcTemplate;

public class joinCount {
    public int joinCount(String subject_id, JdbcTemplate jdbcTemplate){
        int joincount=0;
        String sql1="select count(1) num from sparta_exam_subject_student where subject_id="+subject_id+" and quekao=0 and student_id not in (select student_id from sparta_exam_student where examroom_id =647)";
        joincount = jdbcTemplate.queryForObject(sql1, Integer.class);
        return joincount;
    }
}
